Skip to main content

What’s New

Qrvey 8.7
Version 8.7 of the Qrvey platform is now available to customers! This version includes new features including area charts, the ability to pivot and export data, as well as numerous bug fixes and performance improvements.
Learn More
Qrvey 8.6
Version 8.6 of the Qrvey platform is now available to customers. This version includes several new feature enhancements and performance improvements.
Learn More
Required Update for 8.5.1
Attention 8.5.1 customers: for any 8.5.1 instance deployed prior to 08/05/2024, an update is required to ensure you are running the latest images.
Learn More
Qrvey 8.5
Version 8.5 (LTS) of the Qrvey platform is now available to customers. This version includes several new features and performance improvements.
Learn More
End-of-life Schedule
We've added a new article that lists the features and endpoints that have been scheduled for deprecation. All features and endpoints will be supported for (1) year after the release date of the LTS version that contains the alternative.
Learn More
Version: 8.1

Multiseries Combo Chart

The Multiseries Combo Chart is used to view multiple metrics over multiple dimensions. It combines a Multiseries Chart with any number of layers of any type of X/Y Chart (Bar Chart, Line Chart, and Symbol Chart). Use a Multiseries Combo Chart to create a visualization with one category, one series, and two or more values.

ms-combo-chart-82

Creating a Multiseries Combo Chart​

To create a Multiseries Combo Chart, drag a data field from the Data panel onto either the corresponding shelf or the canvas. The Multiseries Combo Chart requires a category, a series, and at least two values in the shelves.

In the case below, we’d like to better understand which customers are purchasing our high-margin products. The Multiseries Combo Chart below displays a bar chart of each product (productName) on the x-axis and the quantity of items sold (quantityOrdered) on the y-axis. The bar chart is stacked to display the customers of each product (customerName) and the number of units they purchased (quantityOrdered). When analyzing the product sales, we’d also like to consider the profit margin of each product. The chart also displays the wholesale cost of each product (buyPrice) as an upward-facing triangle and the price the customer paid (priceEach) as a downward-facing triangle. The distance between the two triangles provides a visual indicator of the price and profitability of the product. Using this chart, we can quickly see which products have high (or low) margins and identify the customers who purchase them.

ms-combo-chart-example-82

Styling the Multiseries Combo Chart​

General​

  • Legends - show or hide the legend describing which color has been used to depict each selected value.
  • Tooltips - enable or disable Tooltips to show more than one value on mouseover. Click +Add Column to add a column.
    • Column - pick a column from the dropdown list. This can be any column, even if it is not used in the chart.
    • Display Values As - choose the aggregation type for each additional column you’d like to display in the tooltip (Sum, Average, Median, Count, Distinct Count, Minimum, Maximum).
    • Values Format - set the format of the values on the scale choosing between Default, Abbreviated, Decimal (set a number of decimals), Currency (choose the currency from the drop-down menu and set a number of decimals), Percentage (set a number of decimals), Scientific.
    • Remove - remove the tooltip column.
    • Header - add a header to the tooltip.
  • Table Calculations - add calculations to your Combo Chart.
  • Max Data Points - set the upper limit for the categories that are shown on the x-axis of the combo chart. Controlling the number of symbols helps you manage the clarity and organization of the chart - if you have too many data points, the chart can quickly become unreadable.
  • Max Series - Increase or decrease a limit on the series you want to show in a single category in a multiseries chart.

Styles​

  • Theme - Set a theme that applies to the Series and the Combo values.
  • Multiseries Type - select whether to display the chart as Bar, Line, or Symbol.
  • X-axis
    • Axis Title - select whether to display the axis title.
    • Value Labels - select whether to display the value labels.
    • Values Rotation - if values are enabled, decide how you want them to be displayed.
    • Typeface - select the typeface of the labels.
    • Weight - select the font weight of the labels.
    • Size - select the font size of the labels.
    • Font Color - select the font color of the labels.
  • Y-axis
    • Axis Title - select whether to display the axis title.
    • Value Labels - select whether to display the value labels.
    • Values Rotation - if values are enabled, decide how you want them to be displayed.
    • Typeface - select the typeface of the labels.
    • Weight - select the font weight of the labels.
    • Size - select the font size of the labels.
    • Font Color - select the font color of the labels.
  • Bar Width - manually set the width of the bars.
  • Type - Choose whether you want your bars to appear side by side or stacked. combo

Sorting​

Multiseries Combo Charts can be sorted by their selected category column, or either of the value columns used in them. Choose the column that you wish to sort your chart by, from the dropdown list and select the sorting direction (ascending or descending) from the icons under the dropdown.

For more information, see Sorting.

Layers​

Add a Trend Line or a Reference Line to your Multiseries Combo Charts.

Format​

The Conditional Formatting option is available in Multiseries Combo Charts.

Filters​

You can also add Filters to your data by expanding the Filters section in the configuration panel or by clicking on the Filters button in the toolbar above the canvas.

Filters that are created in the Chart Builder are hidden from End Users. These types of filters can’t be edited or interacted with in the view mode. For more information on the types of filters, see Chart Filters.

Multiseries Combo Charts supports Filter By, which applies a filter over the chart’s data when users click on a data point.